Customizing the Refund File

The standard refund file created by IntelleCheck includes payment number, amount, payee, and Banner Id. In some cases, additional id fields may need to be included in the refund file to provide extended search criteria through BankMobileAdminSupport.com. To include additional fields, an Oracle view, named EVIBCHO_VIEW, needs to be created in the Banner environment. Once this view exists, IntelleCheck will include the additional fields in the refund file.

Important Note: The EVIBCHO_VIEW should be created in the Evisions schema. A public synonym should also be created.

CREATE OR REPLACE VIEW EVISIONS.EVIBCHO_VIEW AS
SELECT EVIBCCHK_CHECK_NUMBER AS CHECK_NUMBER, -- required
	EVIBCCHK_ACCOUNT_CODE AS ACCOUNT_CODE, -- required
	EVIBCCHK_ACCOUNT_TYPE AS ACCOUNT_TYPE, -- required
	EVIBCCHK_BATCH_ID AS BATCH_ID,         -- required
	TABLE1_DATA1 AS ID2, -- custom data
	TABLE2_DATA2 AS ID3  -- custom data
FROM EVIBCCHK, TABLE1, TABLE2
WHERE EVIBCCHK_PIDM = TABLE1.PIDM
AND EVIBCCHK_PIDM = TABLE2.PIDM;

CREATE PUBLIC SYNONYM EVIBCHO_VIEW FOR EVISIONS.EVIBCHO_VIEW

In the sample script above, you would need to replace TABLE1 and TABLE2 and related data fields with the names of the tables containing the additional information to be included in the refund file. If for any reason the additional information can not be found, the refund file will still be created and sent with the standard fields to prevent a delay in payment.